package net.adetech.cjg.innerservice.mapper;


import net.adetech.cjg.innerservice.entity.Zs;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface ZsDao {

    @Select("select * from cjg_zs where ip = #{ip}")
    Zs getZsByIp(String ip);


    @Update("update cjg_zs set yzm=#{yzm,jdbcType=CLOB},zt = #{zt,jdbcType=VARCHAR},sxsj = sysdate where ip = #{ip}")
    void saveYzm(Zs zs);


    @Update("update cjg_zs set zt = #{zt,jdbcType=VARCHAR},sxsj = sysdate where ip = #{ip}")
    void saveZt(Zs zs);

    @Update("update cjg_zs set dldz=#{dldz,jdbcType=VARCHAR},zt = #{zt,jdbcType=VARCHAR},zhlx = #{zhlx},sxsj = sysdate,yzm = null where ip = #{ip}")
    void saveUrl(Zs zs);



}
